Introduction

This report takes the SQL outputs and runs some initial trend analysis to visualise any outliers/pull out key trends ahead of writing any commentary.

Trend checks - national

This section checks the national trends over the last 4 years to make sure the data is looking sensible

Pupil numbers

The following checks look at pupil numbers by year

Number of pupils by social care group

Number of CIN pupils at any point by SEN status

Average attainment 8

The following checks look at average attainment 8 by year. The maximum attainment 8 score is 90.

% achieving 9-5 L2 basics

The following checks look at the percentage of pupils achieving 9-5 in Level 2 basics by year.

% entering EBacc

The following checks look at percentage of pupils entering the EBacc by year.

% acheiving 9-5 EBacc

The following checks look at percentage of pupils acheiving levels 9-5 in the EBacc by year.

EBacc average point score

The following checks look at the EBacc average point score by year.

Trend checks - LA

This section checks the local authority trends over the last 4 years to make sure the data is looking sensible.

Double click a region in the legend to isolate the LAs inside it.

Number of pupils by LA, this year compared to last year

Avg att 8 by LA, this year compared to last year

% achieving 9-5 in L2 basics, this year compared to last year

% entering EBacc, this year compared to last year

% achieving 9-5 in EBacc, this year compared to last year

Average EBacc APS, this year compared to last year

Gap analysis sense checks

This section looks at the difference in various measures between pupils in the different social care groups and “all pupils”, year to year

Average attainment 8 difference to all pupils

% achieving 9-5 in L2 basics difference to all pupils

% entering EBacc difference to all pupils

% achieving 9-5 EBacc difference to all pupils

EBacc APS difference to all pupils

Geography sense checks

LA and region totals match

For non calculated columns (i.e. not average or percentage), the LA subtotals should add up to their region totals. A table will display below of the regions and years that do not match if this is not the case.

## [1] "LA subtotals add up to their region totals"

Region and national totals check

Region subtotals should not add up to the national total as different filters are used. The table below shows the difference between regional subtotals and national figures.

time_period t_pupils_diff t_att8_diff t_l2basics_95_diff t_l2basics_94_diff t_ebacc_e_ptq_ee_diff t_ebacc_95_diff t_ebacc_94_diff t_ebaccaps
201617 40519 864689.8 4978 9786 6402 2280 2716 0.00
201718 43793 920322.7 5355 9756 7442 1774 2983 75628.94
201819 76295 1918139.8 11992 22080 16692 4159 7064 160776.08
201920 81308 2260787.8 15636 27983 18218 5897 9779 189859.48

No old geographies in 201920

Bournemouth, Poole and Dorset all ceased to be LAs from 201920, so shouldn’t exist in our 201920 data. A table will display below of rows where this is not the case.

time_period region_name la_name new_la_code social_care_group pupil_sen_status t_pupils
201920 South West Dorset (up to 2019) E10000009 Ever CIN - last 6 years All pupils 477
201920 South West Dorset (up to 2019) E10000009 Ever CIN - last 6 years No identified SEN 246
201920 South West Dorset (up to 2019) E10000009 Ever CIN - last 6 years All SEN 192
201920 South West Dorset (up to 2019) E10000009 Ever CIN - last 6 years Statement or EHC plan 75
201920 South West Dorset (up to 2019) E10000009 Ever CIN - last 6 years SEN support 117
201920 South West Poole (up to 2019) E06000029 Ever CIN - last 6 years All pupils 251
201920 South West Poole (up to 2019) E06000029 Ever CIN - last 6 years No identified SEN 127
201920 South West Poole (up to 2019) E06000029 Ever CIN - last 6 years All SEN 104
201920 South West Poole (up to 2019) E06000029 Ever CIN - last 6 years Statement or EHC plan 29
201920 South West Poole (up to 2019) E06000029 Ever CIN - last 6 years SEN support 75
201920 South West Bournemouth (up to 2019) E06000028 Ever CIN - last 6 years All pupils 230
201920 South West Bournemouth (up to 2019) E06000028 Ever CIN - last 6 years No identified SEN 120
201920 South West Bournemouth (up to 2019) E06000028 Ever CIN - last 6 years All SEN 85
201920 South West Bournemouth (up to 2019) E06000028 Ever CIN - last 6 years Statement or EHC plan 36
201920 South West Bournemouth (up to 2019) E06000028 Ever CIN - last 6 years SEN support 49

No new geographies pre-201920

“Bournemouth, Chirstchurch and Poole” became a single LA in 201920, so shouldn’t exist in any data from before 201920. A table will display below of rows where this is not the case.

time_period region_name la_name new_la_code social_care_group pupil_sen_status t_pupils
201617 South West Bournemouth, Christchurch and Poole (2020 onwards) E06000058 CLA at any point All pupils 0
201617 South West Bournemouth, Christchurch and Poole (2020 onwards) E06000058 CLA at any point No identified SEN 0
201617 South West Bournemouth, Christchurch and Poole (2020 onwards) E06000058 CLA at any point All SEN 0
201617 South West Bournemouth, Christchurch and Poole (2020 onwards) E06000058 CLA at any point Statement or EHC plan 0

Other sense checks

Number achieving 9-4 >= number achieving 9-5

The number of pupils achieving a 9-4 in English and Maths should be greater than or equal to the number achieving a 9-5. A table below will appear showing all rows where this is not the case, if any exist.

## [1] "The number of pupils achieving a 9-4 in English and maths is greater than or equal to the number achieving a 9-5"

Number achieving 9-4 >= number achieving 9-5 EBacc

The number of pupils achieving a 9-4 in EBacc subjects should be greater than or equal to the number achieving a 9-5. A table below will appear showing all rows where this is not the case, if any exist.

## [1] "The number of pupils achieving a 9-4 in EBacc is greater than or equal to the number achieving a 9-5"

SEN totals add up as expected

The totals for SEN pupils with and without statements should add up to the totals for all SEN pupils. A table below will appear showing all rows where this is not the case, if any exist.

## [1] "The totals for SEN pupils with a statment and SEN pupils without a statement add up to the totals for all SEN"

The total SEN and no identified SEN will not add up to “all pupils” as there is an “unknown” category too which is not accounted for here.

Unknown SEN totals are sensible

A small percentage of pupils each year have an unknown SEN status. The table below shows this number and the number as a percentage of all pupils.

time_period t_pupils_unknown t_pupils_unknown_perc
201617 19698 0.1
201718 23505 0.1
201819 38713 0.1
201920 50627 0.1

CIN totals are sensible

In theory CIN = CINO + CPPO + CLA, however, in practice they won’t add up exactly as some CLA do not match to CIN. However, it would be good to do some checks on this to see the scale of the differences. This looks at the number of pupils each year for the following caluclations to check:

  • CIN_At31 – CINO_At31 – CPPO_At31 - CLA_12Months – CLA_Less_12Months_At31 as a percentage of CLA_12Months + CLA_Less_12Months_At31

  • CIN_AnyPoint – CINO_AnyPoint – CPPO_AnyPOint - CLA_Anypoint as a percentage of CLA_Anypoint

time_period CIN_31_check CIN_31_check_perc CIN_any_check CIN_any_check_perc
201617 -1517 -23.4 3269 44.4
201718 -1338 -20.4 3408 46.4
201819 -1389 -20.3 3849 50.8
201920 -1364 -18.6 3903 48.0